/*
 Navicat Premium Data Transfer

 Source Server         : 本地mysql
 Source Server Type    : MySQL
 Source Server Version : 80024 (8.0.24)
 Source Host           : 127.0.0.1:3306
 Source Schema         : ibp_myspringboot

 Target Server Type    : MySQL
 Target Server Version : 80024 (8.0.24)
 File Encoding         : 65001

 Date: 14/03/2024 16:58:16
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `age` int DEFAULT NULL,
  `sex` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `role_id` varchar(255) DEFAULT '1',
  `pic` varchar(500) DEFAULT NULL,
  `isdel` tinyint DEFAULT NULL,
  `createtime` datetime DEFAULT NULL,
  `updatetime` datetime DEFAULT NULL,
  `deletetime` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` (`id`, `username`, `password`, `age`, `sex`, `phone`, `role_id`, `pic`, `isdel`, `createtime`, `updatetime`, `deletetime`) VALUES ('12334555', 'admin1', '123456', 18, '女', '1234567890', '1', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user` (`id`, `username`, `password`, `age`, `sex`, `phone`, `role_id`, `pic`, `isdel`, `createtime`, `updatetime`, `deletetime`) VALUES ('12345678321', 'admin2', '123456', 18, '女', '1234567890', '1', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user` (`id`, `username`, `password`, `age`, `sex`, `phone`, `role_id`, `pic`, `isdel`, `createtime`, `updatetime`, `deletetime`) VALUES ('1234567322', 'admin3', '123456', 18, '女', '1234567890', '1', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user` (`id`, `username`, `password`, `age`, `sex`, `phone`, `role_id`, `pic`, `isdel`, `createtime`, `updatetime`, `deletetime`) VALUES ('1720327274814914562', 'jdhh', '135246', 23, '男', '1234567890', '1', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user` (`id`, `username`, `password`, `age`, `sex`, `phone`, `role_id`, `pic`, `isdel`, `createtime`, `updatetime`, `deletetime`) VALUES ('1720328534381182977', 'jdhh111', '135246', 23, '男', '1234567890', '1', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user` (`id`, `username`, `password`, `age`, `sex`, `phone`, `role_id`, `pic`, `isdel`, `createtime`, `updatetime`, `deletetime`) VALUES ('1720328786286886913', 'jdhh111222', '135246', 23, '男', '1234567890', '1', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user` (`id`, `username`, `password`, `age`, `sex`, `phone`, `role_id`, `pic`, `isdel`, `createtime`, `updatetime`, `deletetime`) VALUES ('1720330940124905474', 'jdhh111222', '135246', 23, '男', '1234567890', '1', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user` (`id`, `username`, `password`, `age`, `sex`, `phone`, `role_id`, `pic`, `isdel`, `createtime`, `updatetime`, `deletetime`) VALUES ('1720332651711315969', 'hsjhhf', '135246', 12, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user` (`id`, `username`, `password`, `age`, `sex`, `phone`, `role_id`, `pic`, `isdel`, `createtime`, `updatetime`, `deletetime`) VALUES ('1720333878226468866', 'addad', '135246', 12, '女', NULL, '1', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user` (`id`, `username`, `password`, `age`, `sex`, `phone`, `role_id`, `pic`, `isdel`, `createtime`, `updatetime`, `deletetime`) VALUES ('1720349122445422593', '42jshsggss', '135246', 23, '男', '1234567890', '1', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user` (`id`, `username`, `password`, `age`, `sex`, `phone`, `role_id`, `pic`, `isdel`, `createtime`, `updatetime`, `deletetime`) VALUES ('1721404888161873922', 'admin', '135246', 25, '男', NULL, '1', NULL, NULL, NULL, NULL, NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
